SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dta_tpl_prop
-- ----------------------------
DROP TABLE IF EXISTS `dta_tpl_prop`;
CREATE TABLE `dta_tpl_prop` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `model_code` varchar(20) NOT NULL COMMENT '模型编码',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '数据类型;数据字典prop_data_type',
  `view_type` varchar(10) NOT NULL COMMENT '展示类型;数据字典prop_view_type',
  `src_type` varchar(10) NOT NULL COMMENT '来源类型;数据字典prop_source_type',
  `quick_sw` varchar(10) DEFAULT '0' COMMENT '快捷搜索',
  `advance_sw` varchar(10) DEFAULT '0' COMMENT '高级搜索',
  `view_sw` varchar(10) DEFAULT '0' COMMENT '列表显示',
  `hide_code` varchar(20) DEFAULT NULL COMMENT '隐藏编码',
  `col_code` varchar(10) DEFAULT NULL COMMENT '索引字段;数据库字段，查询使用',
  `col_num` int(11) DEFAULT 50 COMMENT '显示排序',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `edit_flag` int(11) DEFAULT 0 COMMENT '修改标记;0新增1变更2内置4停用',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据属性A';

-- ----------------------------
-- Records of dta_tpl_prop
-- ----------------------------
BEGIN;
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys1', 'TPL0000', 'uid', '主键ID', 'B', 'B0', '0', '0', '0', '0', 'sys1', 'sys1', 1, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys2', 'TPL0000', 'pid', '上级ID', 'B', 'B0', '0', '0', '0', '0', 'sys2', 'sys2', 2, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":20}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys3', 'TPL0000', 'mid', '主线ID', 'B', 'B0', '0', '0', '0', '0', 'sys3', 'sys3', 3, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys4', 'TPL0000', 'mco', '主编码', 'A', 'A1', '1', '1', '0', '1', 'sys4', 'sys4', 4, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 1, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys5', 'TPL0000', 'cco', '分类编码', 'A', 'X1', '0', '1', '1', '1', 'sys5', 'sys5', 5, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys6', 'TPL0000', 'lco', '层级编码', 'A', 'X1', '0', '0', '0', '0', 'sys6', 'sys6', 6, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":100}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys7', 'TPL0000', 'type_src', '来源类型', 'A', 'X1', '0', '0', '0', '1', 'sys7', 'sys7', 7, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":10}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys80', 'TPL0000', 'mvs', '模型版本', 'B', 'B0', '0', '0', '0', '1', 'sys80', 'sys80', 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys81', 'TPL0000', 'remark', '备注', 'A', 'A1', '1', '0', '1', '0', 'sys81', 'sys81', 81, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":300}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys82', 'TPL0000', 'vip_level', '访问级别', 'B', 'B0', '0', '0', '0', '0', 'sys82', 'sys82', 82, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys83', 'TPL0000', 'dept_id', '归属单位', 'A', 'X1', '0', '0', '0', '1', 'sys83', 'sys83', 83, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys84', 'TPL0000', 'tenant_id', '租户号', 'A', 'X1', '0', '0', '0', '0', 'sys84', 'sys84', 84, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys85', 'TPL0000', 'create_by', '创建人', 'A', 'X1', '0', '0', '0', '0', 'sys85', 'sys85', 85, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys86', 'TPL0000', 'create_time', '创建时间', 'C', 'X1', '0', '0', '0', '0', 'sys86', 'sys86', 86, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys87', 'TPL0000', 'update_by', '更新人', 'A', 'X1', '0', '0', '0', '0', 'sys87', 'sys87', 87, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys88', 'TPL0000', 'update_time', '更新时间', 'C', 'X1', '0', '0', '0', '0', 'sys88', 'sys88', 88, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys89', 'TPL0000', 'task_id', '任务ID', 'A', 'X1', '0', '0', '0', '1', 'sys89', 'sys89', 89, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys90', 'TPL0000', 'task_state', '任务运行态', 'B', 'B0', '0', '0', '0', '1', 'sys90', 'sys90', 90, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys91', 'TPL0000', 'revision', '乐观锁', 'B', 'B0', '0', '0', '0', '0', 'sys91', 'sys91', 91, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
